IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'ServiceCreate')
	BEGIN
		DROP  Procedure  ServiceCreate
	END

GO

CREATE Procedure ServiceCreate
(
	@accountId int,
	@title nvarchar(200),
	@serviceId int OUTPUT
)
AS

INSERT INTO Services
	(AccountId, Title, CreateDate, UpdateDate)
VALUES
	(@accountId, @title, GETDATE(), GETDATE())

SET @serviceId = SCOPE_IDENTITY()

GO